set IDENTITY_INSERT userInfo ON
declare @xx INT
declare @username nvarchar(20)
declare @r NVARCHAR(20)
set @xx=1
set @username=RAND(1000)*1000000
if @xx=1
	print 'xxxx'

while @xx<=10000
BEGIN
	insert into userInfo
	(
		id,
		username,
		pwd,
		regDate,
		email,
		qq,
		tel,
		purview,
		parentid
	)
	VALUES
	(
		@xx,
		@username,
		'111',
		'2013-04-20',
		'lhl62411570@126.com',
		'77011492',
		'13600273055',
		 1,
		RAND(1000)
	)
	set @xx+=1
	set @username=rand(10000)*1000000+@xx
END
set IDENTITY_INSERT userInfo OFF
